﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Globalization;

/// <summary>
/// Summary description for clsSearchResume
/// </summary>
public class clsSearchResume
{
    InstantNaukriDataContextDataContext objInstantNaukriDataContextDataContext = new InstantNaukriDataContextDataContext();
    public clsSearchResume()
    {
        //
        // TODO: Add constructor logic here
        //
    }

    public clsResumeSearchResultBo GetResumeByUserId(int UserId)
    {
        try
        {

            clsResumeSearchResultBo objclsSearchResultList = new clsResumeSearchResultBo();
            objclsSearchResultList = (from obj in objInstantNaukriDataContextDataContext.IN_TB_PROFILEs
                                      join objResume in objInstantNaukriDataContextDataContext.IN_TB_RESUME_MSTs on obj.USER_ID equals objResume.USER_ID
                                      where objResume.USER_ID == UserId
                                      select new clsResumeSearchResultBo
                                      {
                                          USER_ID = (int)obj.USER_ID,
                                          CANDIDATE_NAME = Convert.ToString(obj.F_NAME) + "  " + Convert.ToString(obj.M_NAME) + "  " + Convert.ToString(obj.L_NAME),
                                          EMAIL = Convert.ToString(obj.EMAIL),
                                          MOBILE = Convert.ToString(obj.MOBILE),
                                          PHONE = Convert.ToString(obj.PHONE),
                                          EXPERIENCE = Convert.ToString(objResume.TOTAL_EXP),
                                          CURRENT_COMPANY = Convert.ToString(objResume.CURRENT_DESIGNATION),
                                          CURRENT_POST = Convert.ToString(objResume.CURRENT_DESIGNATION),
                                          CURRENT_LOCATION = (int)(objResume.CURRENT_LOCATION),
                                          CURRENT_CTC = Convert.ToString(objResume.CTC),
                                          FUNCTIONAL_AREA = (int)(objResume.FUNCTIONAL_AREA),
                                          PREFERRED_LOCATION = Convert.ToString(objResume.PREFERRED_LOCATION),
                                          SKILL_SET = Convert.ToString(objResume.KEY_SKILLS),
                                          CV_PATH = Convert.ToString(objResume.RESUME_PATH),
                                          RESUME_HEADLINE = Convert.ToString(objResume.RESUME_HEADLINE)

                                      }
                                          ).SingleOrDefault();



            return objclsSearchResultList;
        }
        catch (Exception ex)
        {

            throw ex;
        }
    }

    public List<clsResumeSearchResultBo> GetResumeBySkills(string[] Skills)
    {
        try
        {
            List<clsResumeSearchResultBo> objclsSearchResultList = new List<clsResumeSearchResultBo>();
            List<clsResumeSearchResultBo> objclsSearchResultFinalList = new List<clsResumeSearchResultBo>();
            for (int i = 0; i <= Skills.Length - 1; i++)
            {
                objclsSearchResultList = new List<clsResumeSearchResultBo>();
                objclsSearchResultList = (from obj in objInstantNaukriDataContextDataContext.IN_TB_PROFILEs
                                          join objResume in objInstantNaukriDataContextDataContext.IN_TB_RESUME_MSTs on obj.USER_ID equals objResume.USER_ID
                                          where objResume.KEY_SKILLS.ToLower().Contains(Skills[i].ToLower())
                                          select new clsResumeSearchResultBo
                                          {
                                              USER_ID = (int)obj.USER_ID,
                                              CANDIDATE_NAME = Convert.ToString(obj.F_NAME) + "  " + Convert.ToString(obj.M_NAME) + "  " + Convert.ToString(obj.L_NAME),
                                              EMAIL = Convert.ToString(obj.EMAIL),
                                              MOBILE = Convert.ToString(obj.MOBILE),
                                              PHONE = Convert.ToString(obj.PHONE),
                                              EXPERIENCE = Convert.ToString(objResume.TOTAL_EXP),
                                              CURRENT_COMPANY = Convert.ToString(objResume.CURRENT_DESIGNATION),
                                              CURRENT_POST = Convert.ToString(objResume.CURRENT_DESIGNATION),
                                              CURRENT_LOCATION = (int)(objResume.CURRENT_LOCATION),
                                              CURRENT_CTC = Convert.ToString(objResume.CTC),
                                              FUNCTIONAL_AREA = (int)(objResume.FUNCTIONAL_AREA),
                                              PREFERRED_LOCATION = Convert.ToString(objResume.PREFERRED_LOCATION),
                                              SKILL_SET = Convert.ToString(objResume.KEY_SKILLS),
                                              CV_PATH = Convert.ToString(objResume.RESUME_PATH),
                                              RESUME_HEADLINE = Convert.ToString(objResume.RESUME_HEADLINE)

                                          }
                                              ).ToList();

                foreach (clsResumeSearchResultBo item in objclsSearchResultList)
                {
                    objclsSearchResultFinalList.Add(item);
                }

            }
            return objclsSearchResultFinalList;
        }
        catch (Exception ex)
        {

            throw ex;
        }
    }

    public List<clsResumeSearchResultBo> GetResumeByExperience(int MinExperience, int MaxExperience)
    {
        try
        {
            List<clsResumeSearchResultBo> objclsSearchResultList = new List<clsResumeSearchResultBo>();
            List<clsResumeSearchResultBo> objclsSearchResultFinalList = new List<clsResumeSearchResultBo>();

            objclsSearchResultList = new List<clsResumeSearchResultBo>();
            objclsSearchResultList = (from obj in objInstantNaukriDataContextDataContext.IN_TB_PROFILEs
                                      join objResume in objInstantNaukriDataContextDataContext.IN_TB_RESUME_MSTs on obj.USER_ID equals objResume.USER_ID
                                      where objResume.TOTAL_EXP >= MinExperience && objResume.TOTAL_EXP <= MaxExperience
                                      select new clsResumeSearchResultBo
                                      {
                                          USER_ID = (int)obj.USER_ID,
                                          CANDIDATE_NAME = Convert.ToString(obj.F_NAME) + "  " + Convert.ToString(obj.M_NAME) + "  " + Convert.ToString(obj.L_NAME),
                                          EMAIL = Convert.ToString(obj.EMAIL),
                                          MOBILE = Convert.ToString(obj.MOBILE),
                                          PHONE = Convert.ToString(obj.PHONE),
                                          EXPERIENCE = Convert.ToString(objResume.TOTAL_EXP),
                                          CURRENT_COMPANY = Convert.ToString(objResume.CURRENT_DESIGNATION),
                                          CURRENT_POST = Convert.ToString(objResume.CURRENT_DESIGNATION),
                                          CURRENT_LOCATION = Convert.ToInt32(objResume.CURRENT_LOCATION),
                                          CURRENT_CTC = Convert.ToString(objResume.CTC),
                                          FUNCTIONAL_AREA = Convert.ToInt32(objResume.FUNCTIONAL_AREA),
                                          PREFERRED_LOCATION = Convert.ToString(objResume.PREFERRED_LOCATION),
                                          SKILL_SET = Convert.ToString(objResume.KEY_SKILLS),
                                          CV_PATH = Convert.ToString(objResume.RESUME_PATH),
                                          RESUME_HEADLINE = Convert.ToString(objResume.RESUME_HEADLINE)

                                      }
                                          ).ToList();

            foreach (clsResumeSearchResultBo item in objclsSearchResultList)
            {
                objclsSearchResultFinalList.Add(item);
            }
            return objclsSearchResultFinalList;
        }
        catch (Exception)
        {

            throw;
        }
    }

    public List<clsResumeSearchResultBo> GetResumeByIndustry(string[] Industry)
    {
        try
        {
            List<clsResumeSearchResultBo> objclsSearchResultList = new List<clsResumeSearchResultBo>();
            List<clsResumeSearchResultBo> objclsSearchResultFinalList = new List<clsResumeSearchResultBo>();
            for (int i = 0; i <= Industry.Length - 1; i++)
            {
                objclsSearchResultList = new List<clsResumeSearchResultBo>();
                objclsSearchResultList = (from obj in objInstantNaukriDataContextDataContext.IN_TB_PROFILEs
                                          join objResume in objInstantNaukriDataContextDataContext.IN_TB_RESUME_MSTs on obj.USER_ID equals objResume.USER_ID
                                          where objResume.CURRENT_COMPANY.ToLower().Contains(Industry[i])
                                          select new clsResumeSearchResultBo
                                          {
                                              USER_ID = (int)obj.USER_ID,
                                              CANDIDATE_NAME = Convert.ToString(obj.F_NAME) + "  " + Convert.ToString(obj.M_NAME) + "  " + Convert.ToString(obj.L_NAME),
                                              EMAIL = Convert.ToString(obj.EMAIL),
                                              MOBILE = Convert.ToString(obj.MOBILE),
                                              PHONE = Convert.ToString(obj.PHONE),
                                              EXPERIENCE = Convert.ToString(objResume.TOTAL_EXP),
                                              CURRENT_COMPANY = Convert.ToString(objResume.CURRENT_COMPANY),
                                              CURRENT_POST = Convert.ToString(objResume.CURRENT_DESIGNATION),
                                              CURRENT_LOCATION = Convert.ToInt32(objResume.CURRENT_LOCATION),
                                              CURRENT_CTC = Convert.ToString(objResume.CTC),
                                              FUNCTIONAL_AREA = Convert.ToInt32(objResume.FUNCTIONAL_AREA),
                                              PREFERRED_LOCATION = Convert.ToString(objResume.PREFERRED_LOCATION),
                                              SKILL_SET = Convert.ToString(objResume.KEY_SKILLS),
                                              CV_PATH = Convert.ToString(objResume.RESUME_PATH),
                                              RESUME_HEADLINE = Convert.ToString(objResume.RESUME_HEADLINE)

                                          }
                                              ).ToList();

                foreach (clsResumeSearchResultBo item in objclsSearchResultList)
                {
                    objclsSearchResultFinalList.Add(item);
                }

            }
            return objclsSearchResultFinalList;
        }
        catch (Exception)
        {

            throw;
        }
    }

    public List<clsResumeSearchResultBo> GetResumeByIndustry(int MinExperience, int MaxExperience, int FunctionalAreaId)
    {
        try
        {
            List<clsResumeSearchResultBo> objclsSearchResultList = new List<clsResumeSearchResultBo>();

            objclsSearchResultList = (from obj in objInstantNaukriDataContextDataContext.IN_TB_PROFILEs
                                      join objResume in objInstantNaukriDataContextDataContext.IN_TB_RESUME_MSTs on obj.USER_ID equals objResume.USER_ID
                                      where objResume.TOTAL_EXP >= MinExperience
                                      || objResume.FUNCTIONAL_AREA == FunctionalAreaId
                                      || objResume.TOTAL_EXP <= MaxExperience
                                      select new clsResumeSearchResultBo
                                      {
                                          USER_ID = (int)obj.USER_ID,
                                          CANDIDATE_NAME = Convert.ToString(obj.F_NAME) + "  " + Convert.ToString(obj.M_NAME) + "  " + Convert.ToString(obj.L_NAME),
                                          EMAIL = Convert.ToString(obj.EMAIL),
                                          MOBILE = Convert.ToString(obj.MOBILE),
                                          PHONE = Convert.ToString(obj.PHONE),
                                          EXPERIENCE = Convert.ToString(objResume.TOTAL_EXP),
                                          CURRENT_COMPANY = Convert.ToString(objResume.CURRENT_COMPANY),
                                          CURRENT_POST = Convert.ToString(objResume.CURRENT_DESIGNATION),
                                          CURRENT_LOCATION = Convert.ToInt32(objResume.CURRENT_LOCATION),
                                          CURRENT_CTC = Convert.ToString(objResume.CTC),
                                          FUNCTIONAL_AREA = Convert.ToInt32(objResume.FUNCTIONAL_AREA),
                                          PREFERRED_LOCATION = Convert.ToString(objResume.PREFERRED_LOCATION),
                                          SKILL_SET = Convert.ToString(objResume.KEY_SKILLS),
                                          CV_PATH = Convert.ToString(objResume.RESUME_PATH),
                                          RESUME_HEADLINE = Convert.ToString(objResume.RESUME_HEADLINE)

                                      }
                                     ).ToList();

            return objclsSearchResultList;
        }
        catch (Exception)
        {

            throw;
        }
    }

    public List<clsResumeSearchResultBo> GetResumeAdvanceSearch(string Skills, string Industry, int Experience, int FunctionalAreaId, int LocationId)
    {
        try
        {
            List<clsResumeSearchResultBo> objclsSearchResultList = new List<clsResumeSearchResultBo>();
            List<clsResumeSearchResultBo> objclsSearchResultFinalList = new List<clsResumeSearchResultBo>();

            string[] IndustrySet, SkillSet;


            if (Skills != "")
            {
                if (Industry != "")
                {
                    IndustrySet = Industry.Split(',');
                    for (int i = 0; i <= IndustrySet.Length - 1; i++)
                    {
                        objclsSearchResultFinalList = new List<clsResumeSearchResultBo>();
                        objclsSearchResultList = new List<clsResumeSearchResultBo>();
                        objclsSearchResultList = (from obj in objInstantNaukriDataContextDataContext.IN_TB_PROFILEs
                                                  join objResume in objInstantNaukriDataContextDataContext.IN_TB_RESUME_MSTs on obj.USER_ID equals objResume.USER_ID
                                                  where objResume.CURRENT_COMPANY.ToLower().Contains(IndustrySet[i])
                                                  || objResume.CURRENT_LOCATION == LocationId
                                                  || objResume.FUNCTIONAL_AREA == FunctionalAreaId
                                                  || objResume.TOTAL_EXP == Experience
                                                  select new clsResumeSearchResultBo
                                                  {
                                                      USER_ID = (int)obj.USER_ID,
                                                      CANDIDATE_NAME = Convert.ToString(obj.F_NAME) + "  " + Convert.ToString(obj.M_NAME) + "  " + Convert.ToString(obj.L_NAME),
                                                      EMAIL = Convert.ToString(obj.EMAIL),
                                                      MOBILE = Convert.ToString(obj.MOBILE),
                                                      PHONE = Convert.ToString(obj.PHONE),
                                                      EXPERIENCE = Convert.ToString(objResume.TOTAL_EXP),
                                                      CURRENT_COMPANY = Convert.ToString(objResume.CURRENT_COMPANY),
                                                      CURRENT_POST = Convert.ToString(objResume.CURRENT_DESIGNATION),
                                                      CURRENT_LOCATION = Convert.ToInt32(objResume.CURRENT_LOCATION),
                                                      CURRENT_CTC = Convert.ToString(objResume.CTC),
                                                      FUNCTIONAL_AREA = Convert.ToInt32(objResume.FUNCTIONAL_AREA),
                                                      PREFERRED_LOCATION = Convert.ToString(objResume.PREFERRED_LOCATION),
                                                      SKILL_SET = Convert.ToString(objResume.KEY_SKILLS),
                                                      CV_PATH = Convert.ToString(objResume.RESUME_PATH),
                                                      RESUME_HEADLINE = Convert.ToString(objResume.RESUME_HEADLINE)

                                                  }
                                             ).ToList();

                        foreach (clsResumeSearchResultBo item in objclsSearchResultList)
                        {
                            if (!objclsSearchResultFinalList.Contains(item))
                                objclsSearchResultFinalList.Add(item);
                        }

                    }
                    SkillSet = Skills.Split(',');
                    for (int i = 0; i <= SkillSet.Length - 1; i++)
                    {
                        objclsSearchResultList = new List<clsResumeSearchResultBo>();
                        objclsSearchResultList = (from obj in objInstantNaukriDataContextDataContext.IN_TB_PROFILEs
                                                  join objResume in objInstantNaukriDataContextDataContext.IN_TB_RESUME_MSTs on obj.USER_ID equals objResume.USER_ID
                                                  where objResume.KEY_SKILLS.ToLower().Contains(SkillSet[i])
                                                  || objResume.CURRENT_LOCATION == LocationId
                                                  || objResume.FUNCTIONAL_AREA == FunctionalAreaId
                                                  || objResume.TOTAL_EXP == Experience
                                                  select new clsResumeSearchResultBo
                                                  {
                                                      USER_ID = (int)obj.USER_ID,
                                                      CANDIDATE_NAME = Convert.ToString(obj.F_NAME) + "  " + Convert.ToString(obj.M_NAME) + "  " + Convert.ToString(obj.L_NAME),
                                                      EMAIL = Convert.ToString(obj.EMAIL),
                                                      MOBILE = Convert.ToString(obj.MOBILE),
                                                      PHONE = Convert.ToString(obj.PHONE),
                                                      EXPERIENCE = Convert.ToString(objResume.TOTAL_EXP),
                                                      CURRENT_COMPANY = Convert.ToString(objResume.CURRENT_DESIGNATION),
                                                      CURRENT_POST = Convert.ToString(objResume.CURRENT_DESIGNATION),
                                                      CURRENT_LOCATION = Convert.ToInt32(objResume.CURRENT_LOCATION),
                                                      CURRENT_CTC = Convert.ToString(objResume.CTC),
                                                      FUNCTIONAL_AREA = Convert.ToInt32(objResume.FUNCTIONAL_AREA),
                                                      PREFERRED_LOCATION = Convert.ToString(objResume.PREFERRED_LOCATION),
                                                      SKILL_SET = Convert.ToString(objResume.KEY_SKILLS),
                                                      CV_PATH = Convert.ToString(objResume.RESUME_PATH),
                                                      RESUME_HEADLINE = Convert.ToString(objResume.RESUME_HEADLINE)

                                                  }
                                             ).ToList();

                        foreach (clsResumeSearchResultBo item in objclsSearchResultList)
                        {
                            if (!objclsSearchResultFinalList.Contains(item))
                                objclsSearchResultFinalList.Add(item);
                        }

                    }
                }
                else
                {
                    objclsSearchResultFinalList = new List<clsResumeSearchResultBo>();
                    SkillSet = Skills.Split(',');
                    for (int i = 0; i <= SkillSet.Length - 1; i++)
                    {
                        objclsSearchResultList = new List<clsResumeSearchResultBo>();
                        objclsSearchResultList = (from obj in objInstantNaukriDataContextDataContext.IN_TB_PROFILEs
                                                  join objResume in objInstantNaukriDataContextDataContext.IN_TB_RESUME_MSTs on obj.USER_ID equals objResume.USER_ID
                                                  where objResume.KEY_SKILLS.ToLower().Contains(SkillSet[i])
                                                  || objResume.CURRENT_LOCATION == LocationId
                                                  || objResume.FUNCTIONAL_AREA == FunctionalAreaId
                                                  || objResume.TOTAL_EXP == Experience
                                                  select new clsResumeSearchResultBo
                                                  {
                                                      USER_ID = (int)obj.USER_ID,
                                                      CANDIDATE_NAME = Convert.ToString(obj.F_NAME) + "  " + Convert.ToString(obj.M_NAME) + "  " + Convert.ToString(obj.L_NAME),
                                                      EMAIL = Convert.ToString(obj.EMAIL),
                                                      MOBILE = Convert.ToString(obj.MOBILE),
                                                      PHONE = Convert.ToString(obj.PHONE),
                                                      EXPERIENCE = Convert.ToString(objResume.TOTAL_EXP),
                                                      CURRENT_COMPANY = Convert.ToString(objResume.CURRENT_DESIGNATION),
                                                      CURRENT_POST = Convert.ToString(objResume.CURRENT_DESIGNATION),
                                                      CURRENT_LOCATION = Convert.ToInt32(objResume.CURRENT_LOCATION),
                                                      CURRENT_CTC = Convert.ToString(objResume.CTC),
                                                      FUNCTIONAL_AREA = Convert.ToInt32(objResume.FUNCTIONAL_AREA),
                                                      PREFERRED_LOCATION = Convert.ToString(objResume.PREFERRED_LOCATION),
                                                      SKILL_SET = Convert.ToString(objResume.KEY_SKILLS),
                                                      CV_PATH = Convert.ToString(objResume.RESUME_PATH),
                                                      RESUME_HEADLINE = Convert.ToString(objResume.RESUME_HEADLINE)

                                                  }
                                              ).ToList();

                        foreach (clsResumeSearchResultBo item in objclsSearchResultList)
                        {
                            if (!objclsSearchResultFinalList.Contains(item))
                                objclsSearchResultFinalList.Add(item);
                        }

                    }
                }
            }
            else
            {
                if (Industry != "")
                {
                    objclsSearchResultFinalList = new List<clsResumeSearchResultBo>();
                    IndustrySet = Industry.Split(',');
                    for (int i = 0; i <= IndustrySet.Length - 1; i++)
                    {
                        objclsSearchResultList = new List<clsResumeSearchResultBo>();
                        objclsSearchResultList = (from obj in objInstantNaukriDataContextDataContext.IN_TB_PROFILEs
                                                  join objResume in objInstantNaukriDataContextDataContext.IN_TB_RESUME_MSTs on obj.USER_ID equals objResume.USER_ID
                                                  where objResume.CURRENT_COMPANY.ToLower().Contains(IndustrySet[i])
                                                  || objResume.CURRENT_LOCATION == LocationId
                                                  || objResume.FUNCTIONAL_AREA == FunctionalAreaId
                                                  || objResume.TOTAL_EXP == Experience
                                                  select new clsResumeSearchResultBo
                                                  {
                                                      USER_ID = (int)obj.USER_ID,
                                                      CANDIDATE_NAME = Convert.ToString(obj.F_NAME) + "  " + Convert.ToString(obj.M_NAME) + "  " + Convert.ToString(obj.L_NAME),
                                                      EMAIL = Convert.ToString(obj.EMAIL),
                                                      MOBILE = Convert.ToString(obj.MOBILE),
                                                      PHONE = Convert.ToString(obj.PHONE),
                                                      EXPERIENCE = Convert.ToString(objResume.TOTAL_EXP),
                                                      CURRENT_COMPANY = Convert.ToString(objResume.CURRENT_COMPANY),
                                                      CURRENT_POST = Convert.ToString(objResume.CURRENT_DESIGNATION),
                                                      CURRENT_LOCATION = Convert.ToInt32(objResume.CURRENT_LOCATION),
                                                      CURRENT_CTC = Convert.ToString(objResume.CTC),
                                                      FUNCTIONAL_AREA = Convert.ToInt32(objResume.FUNCTIONAL_AREA),
                                                      PREFERRED_LOCATION = Convert.ToString(objResume.PREFERRED_LOCATION),
                                                      SKILL_SET = Convert.ToString(objResume.KEY_SKILLS),
                                                      CV_PATH = Convert.ToString(objResume.RESUME_PATH),
                                                      RESUME_HEADLINE = Convert.ToString(objResume.RESUME_HEADLINE)

                                                  }
                                              ).ToList();

                        foreach (clsResumeSearchResultBo item in objclsSearchResultList)
                        {
                            if (!objclsSearchResultFinalList.Contains(item))
                                objclsSearchResultFinalList.Add(item);
                        }

                    }
                }
                else
                {
                    objclsSearchResultFinalList = new List<clsResumeSearchResultBo>();
                    objclsSearchResultList = new List<clsResumeSearchResultBo>();
                    objclsSearchResultList = (from obj in objInstantNaukriDataContextDataContext.IN_TB_PROFILEs
                                              join objResume in objInstantNaukriDataContextDataContext.IN_TB_RESUME_MSTs on obj.USER_ID equals objResume.USER_ID
                                              where objResume.CURRENT_LOCATION == LocationId
                                              || objResume.FUNCTIONAL_AREA == FunctionalAreaId
                                              || objResume.TOTAL_EXP == Experience
                                              select new clsResumeSearchResultBo
                                              {
                                                  USER_ID = (int)obj.USER_ID,
                                                  CANDIDATE_NAME = Convert.ToString(obj.F_NAME) + "  " + Convert.ToString(obj.M_NAME) + "  " + Convert.ToString(obj.L_NAME),
                                                  EMAIL = Convert.ToString(obj.EMAIL),
                                                  MOBILE = Convert.ToString(obj.MOBILE),
                                                  PHONE = Convert.ToString(obj.PHONE),
                                                  EXPERIENCE = Convert.ToString(objResume.TOTAL_EXP),
                                                  CURRENT_COMPANY = Convert.ToString(objResume.CURRENT_COMPANY),
                                                  CURRENT_POST = Convert.ToString(objResume.CURRENT_DESIGNATION),
                                                  CURRENT_LOCATION = Convert.ToInt32(objResume.CURRENT_LOCATION),
                                                  CURRENT_CTC = Convert.ToString(objResume.CTC),
                                                  FUNCTIONAL_AREA = Convert.ToInt32(objResume.FUNCTIONAL_AREA),
                                                  PREFERRED_LOCATION = Convert.ToString(objResume.PREFERRED_LOCATION),
                                                  SKILL_SET = Convert.ToString(objResume.KEY_SKILLS),
                                                  CV_PATH = Convert.ToString(objResume.RESUME_PATH),
                                                  RESUME_HEADLINE = Convert.ToString(objResume.RESUME_HEADLINE)

                                              }
                                             ).ToList();

                    foreach (clsResumeSearchResultBo item in objclsSearchResultList)
                    {
                        if (!objclsSearchResultFinalList.Contains(item))
                            objclsSearchResultFinalList.Add(item);
                    }

                }
            }


            return objclsSearchResultFinalList;
        }
        catch (Exception)
        {

            throw;
        }
    }

}